Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 590 |
| Missing cells | 1184 |
| Missing cells (%) | 18.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 48.5 KiB |
| Average record size in memory | 84.2 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 10 |
Variable descriptions
| Leaded Regular Gasoline, U.S. City Average Retail Price | Price of leaded fuel, 0 when discontinued |
|---|---|
| Unleaded Regular Gasoline, U.S. City Average Retail Price | Price of unleaded fuel, 0 when leaded was used |
| Unleaded Premium Gasoline, U.S. City Average Retail Price | Price of premium unleaded fuel |
| All Grades of Gasoline, U.S. City Average Retail Price | Cumulative of all grades of gasoline |
| Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Price of fuel, non-blended |
| Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Price of fuel, blended |
| Regular Motor Gasoline, All Areas, Retail Price | Cumulative mean of all categories |
| On-Highway Diesel Fuel Price | Price for diesel fuel |
Year is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 7 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 3 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Year and 6 other fields | High correlation |
Year is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 7 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 2 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Year and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Year and 6 other fields | High correlation |
Year is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 7 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 6 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Year and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Year and 6 other fields | High correlation |
Year is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 7 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 3 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Year and 7 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Year and 6 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Year and 6 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price has 36 (6.1%) missing values | Missing |
Unleaded Premium Gasoline, U.S. City Average Retail Price has 104 (17.6%) missing values | Missing |
All Grades of Gasoline, U.S. City Average Retail Price has 60 (10.2%) missing values | Missing |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price has 228 (38.6%) missing values | Missing |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price has 264 (44.7%) missing values | Missing |
Regular Motor Gasoline, All Areas, Retail Price has 228 (38.6%) missing values | Missing |
On-Highway Diesel Fuel Price has 264 (44.7%) missing values | Missing |
Date has unique values | Unique |
Leaded Regular Gasoline, U.S. City Average Retail Price has 370 (62.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-08-09 18:53:47.731019 |
|---|---|
| Analysis finished | 2022-08-09 18:54:02.665830 |
| Duration | 14.93 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 590 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.7 KiB |
| Minimum | 1973-01-01 00:00:00 |
|---|---|
| Maximum | 2022-02-01 00:00:00 |
| Distinct | 50 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1997.084746 |
| Minimum | 1973 |
|---|---|
| Maximum | 2022 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 1973 |
|---|---|
| 5-th percentile | 1975 |
| Q1 | 1985 |
| median | 1997 |
| Q3 | 2009 |
| 95-th percentile | 2019 |
| Maximum | 2022 |
| Range | 49 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 14.20476992 |
|---|---|
| Coefficient of variation (CV) | 0.007112752701 |
| Kurtosis | -1.200114098 |
| Mean | 1997.084746 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.0006149448596 |
| Sum | 1178280 |
| Variance | 201.7754885 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1973 | 12 | 2.0% |
| 2010 | 12 | 2.0% |
| 2000 | 12 | 2.0% |
| 2001 | 12 | 2.0% |
| 2002 | 12 | 2.0% |
| 2003 | 12 | 2.0% |
| 2004 | 12 | 2.0% |
| 2005 | 12 | 2.0% |
| 2006 | 12 | 2.0% |
| 2007 | 12 | 2.0% |
| Other values (40) | 470 |
| Value | Count | Frequency (%) |
| 1973 | 12 | |
| 1974 | 12 | |
| 1975 | 12 | |
| 1976 | 12 | |
| 1977 | 12 | |
| 1978 | 12 | |
| 1979 | 12 | |
| 1980 | 12 | |
| 1981 | 12 | |
| 1982 | 12 |
| Value | Count | Frequency (%) |
| 2022 | 2 | 0.3% |
| 2021 | 12 | |
| 2020 | 12 | |
| 2019 | 12 | |
| 2018 | 12 | |
| 2017 | 12 | |
| 2016 | 12 | |
| 2015 | 12 | |
| 2014 | 12 | |
| 2013 | 12 |
Month
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.483050847 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.461486012 |
|---|---|
| Coefficient of variation (CV) | 0.5339285614 |
| Kurtosis | -1.220681216 |
| Mean | 6.483050847 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.004162902133 |
| Sum | 3825 |
| Variance | 11.98188541 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 50 | |
| 2 | 50 | |
| 3 | 49 | |
| 4 | 49 | |
| 5 | 49 | |
| 6 | 49 | |
| 7 | 49 | |
| 8 | 49 | |
| 9 | 49 | |
| 10 | 49 | |
| Other values (2) | 98 |
| Value | Count | Frequency (%) |
| 1 | 50 | |
| 2 | 50 | |
| 3 | 49 | |
| 4 | 49 | |
| 5 | 49 | |
| 6 | 49 | |
| 7 | 49 | |
| 8 | 49 | |
| 9 | 49 | |
| 10 | 49 |
| Value | Count | Frequency (%) |
| 12 | 49 | |
| 11 | 49 | |
| 10 | 49 | |
| 9 | 49 | |
| 8 | 49 | |
| 7 | 49 | |
| 6 | 49 | |
| 5 | 49 | |
| 4 | 49 | |
| 3 | 49 |
Leaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROSPrice of leaded fuel, 0 when discontinued
| Distinct | 182 |
|---|---|
| Distinct (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3375457627 |
| Minimum | 0 |
|---|---|
| Maximum | 1.354 |
| Zeros | 370 |
| Zeros (%) | 62.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.66575 |
| 95-th percentile | 1.207 |
| Maximum | 1.354 |
| Range | 1.354 |
| Interquartile range (IQR) | 0.66575 |
Descriptive statistics
| Standard deviation | 0.4681040839 |
|---|---|
| Coefficient of variation (CV) | 1.386787025 |
| Kurtosis | -0.8931807439 |
| Mean | 0.3375457627 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.877057631 |
| Sum | 199.152 |
| Variance | 0.2191214334 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 370 | |
| 0.55 | 5 | 0.8% |
| 0.528 | 4 | 0.7% |
| 1.197 | 3 | 0.5% |
| 1.297 | 2 | 0.3% |
| 0.6 | 2 | 0.3% |
| 0.607 | 2 | 0.3% |
| 0.626 | 2 | 0.3% |
| 0.63 | 2 | 0.3% |
| 0.629 | 2 | 0.3% |
| Other values (172) | 196 |
| Value | Count | Frequency (%) |
| 0 | 370 | |
| 0.402 | 1 | 0.2% |
| 0.418 | 1 | 0.2% |
| 0.437 | 1 | 0.2% |
| 0.465 | 2 | 0.3% |
| 0.491 | 2 | 0.3% |
| 0.528 | 4 | 0.7% |
| 0.532 | 1 | 0.2% |
| 0.533 | 1 | 0.2% |
| 0.534 | 2 | 0.3% |
| Value | Count | Frequency (%) |
| 1.354 | 1 | |
| 1.352 | 1 | |
| 1.351 | 1 | |
| 1.344 | 1 | |
| 1.335 | 1 | |
| 1.333 | 1 | |
| 1.324 | 1 | |
| 1.321 | 1 | |
| 1.315 | 1 | |
| 1.31 | 1 |
Unleaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of unleaded fuel, 0 when leaded was used
| Distinct | 474 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 36 |
| Missing (%) | 6.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.773546931 |
| Minimum | 0.592 |
|---|---|
| Maximum | 4.09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.592 |
|---|---|
| 5-th percentile | 0.66665 |
| Q1 | 1.11925 |
| median | 1.327 |
| Q3 | 2.48375 |
| 95-th percentile | 3.5907 |
| Maximum | 4.09 |
| Range | 3.498 |
| Interquartile range (IQR) | 1.3645 |
Descriptive statistics
| Standard deviation | 0.9010155023 |
|---|---|
| Coefficient of variation (CV) | 0.5080302564 |
| Kurtosis | -0.5891162738 |
| Mean | 1.773546931 |
| Median Absolute Deviation (MAD) | 0.3955 |
| Skewness | 0.7944872424 |
| Sum | 982.545 |
| Variance | 0.8118289354 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.955 | 4 | 0.7% |
| 1.131 | 4 | 0.7% |
| 1.127 | 3 | 0.5% |
| 1.207 | 3 | 0.5% |
| 1.136 | 3 | 0.5% |
| 1.177 | 3 | 0.5% |
| 1.255 | 3 | 0.5% |
| 1.25 | 3 | 0.5% |
| 1.241 | 3 | 0.5% |
| 0.665 | 3 | 0.5% |
| Other values (464) | 522 | |
| (Missing) | 36 | 6.1% |
| Value | Count | Frequency (%) |
| 0.592 | 1 | |
| 0.594 | 1 | |
| 0.6 | 2 | |
| 0.605 | 1 | |
| 0.616 | 1 | |
| 0.623 | 1 | |
| 0.626 | 1 | |
| 0.627 | 1 | |
| 0.628 | 1 | |
| 0.629 | 2 |
| Value | Count | Frequency (%) |
| 4.09 | 1 | |
| 4.065 | 1 | |
| 3.933 | 1 | |
| 3.927 | 1 | |
| 3.868 | 1 | |
| 3.856 | 1 | |
| 3.816 | 1 | |
| 3.792 | 1 | |
| 3.786 | 2 | |
| 3.764 | 1 |
Unleaded Premium Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of premium unleaded fuel
| Distinct | 428 |
|---|---|
| Distinct (%) | 88.1% |
| Missing | 104 |
| Missing (%) | 17.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.15823251 |
| Minimum | 0.98 |
|---|---|
| Maximum | 4.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.98 |
|---|---|
| 5-th percentile | 1.115 |
| Q1 | 1.33625 |
| median | 1.6805 |
| Q3 | 3.00075 |
| 95-th percentile | 3.9555 |
| Maximum | 4.35 |
| Range | 3.37 |
| Interquartile range (IQR) | 1.6645 |
Descriptive statistics
| Standard deviation | 0.9755398661 |
|---|---|
| Coefficient of variation (CV) | 0.4520086976 |
| Kurtosis | -1.079366983 |
| Mean | 2.15823251 |
| Median Absolute Deviation (MAD) | 0.51 |
| Skewness | 0.6107838416 |
| Sum | 1048.901 |
| Variance | 0.9516780304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.421 | 3 | 0.5% |
| 1.411 | 3 | 0.5% |
| 1.367 | 3 | 0.5% |
| 1.268 | 3 | 0.5% |
| 1.36 | 3 | 0.5% |
| 1.441 | 2 | 0.3% |
| 1.323 | 2 | 0.3% |
| 1.339 | 2 | 0.3% |
| 1.282 | 2 | 0.3% |
| 1.1 | 2 | 0.3% |
| Other values (418) | 461 | |
| (Missing) | 104 | 17.6% |
| Value | Count | Frequency (%) |
| 0.98 | 1 | |
| 0.984 | 1 | |
| 0.987 | 1 | |
| 0.999 | 1 | |
| 1.007 | 1 | |
| 1.01 | 1 | |
| 1.045 | 1 | |
| 1.047 | 1 | |
| 1.052 | 1 | |
| 1.061 | 1 |
| Value | Count | Frequency (%) |
| 4.35 | 1 | |
| 4.319 | 1 | |
| 4.244 | 1 | |
| 4.194 | 1 | |
| 4.192 | 1 | |
| 4.148 | 1 | |
| 4.14 | 1 | |
| 4.138 | 1 | |
| 4.102 | 1 | |
| 4.1 | 1 |
All Grades of Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGCumulative of all grades of gasoline
| Distinct | 441 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 60 |
| Missing (%) | 10.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.865362264 |
| Minimum | 0.629 |
|---|---|
| Maximum | 4.142 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.629 |
|---|---|
| 5-th percentile | 0.91415 |
| Q1 | 1.18675 |
| median | 1.3795 |
| Q3 | 2.605 |
| 95-th percentile | 3.6613 |
| Maximum | 4.142 |
| Range | 3.513 |
| Interquartile range (IQR) | 1.41825 |
Descriptive statistics
| Standard deviation | 0.9008868246 |
|---|---|
| Coefficient of variation (CV) | 0.4829554248 |
| Kurtosis | -0.6786153734 |
| Mean | 1.865362264 |
| Median Absolute Deviation (MAD) | 0.4015 |
| Skewness | 0.7679061702 |
| Sum | 988.642 |
| Variance | 0.8115970708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.222 | 5 | 0.8% |
| 1.193 | 5 | 0.8% |
| 1.353 | 4 | 0.7% |
| 1.318 | 4 | 0.7% |
| 1.199 | 3 | 0.5% |
| 1.223 | 3 | 0.5% |
| 1.244 | 3 | 0.5% |
| 1.186 | 3 | 0.5% |
| 1.243 | 3 | 0.5% |
| 1.233 | 3 | 0.5% |
| Other values (431) | 494 | |
| (Missing) | 60 | 10.2% |
| Value | Count | Frequency (%) |
| 0.629 | 2 | |
| 0.631 | 2 | |
| 0.637 | 1 | |
| 0.645 | 1 | |
| 0.655 | 1 | |
| 0.663 | 1 | |
| 0.669 | 1 | |
| 0.671 | 1 | |
| 0.676 | 1 | |
| 0.685 | 1 |
| Value | Count | Frequency (%) |
| 4.142 | 1 | |
| 4.115 | 1 | |
| 3.982 | 1 | |
| 3.976 | 1 | |
| 3.918 | 1 | |
| 3.908 | 1 | |
| 3.863 | 1 | |
| 3.839 | 2 | |
| 3.838 | 1 | |
| 3.813 | 1 |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of fuel, non-blended
| Distinct | 331 |
|---|---|
| Distinct (%) | 91.4% |
| Missing | 228 |
| Missing (%) | 38.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.098372928 |
| Minimum | 0.9 |
|---|---|
| Maximum | 4.002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.9 |
|---|---|
| 5-th percentile | 1.03915 |
| Q1 | 1.22175 |
| median | 2.105 |
| Q3 | 2.76875 |
| 95-th percentile | 3.6048 |
| Maximum | 4.002 |
| Range | 3.102 |
| Interquartile range (IQR) | 1.547 |
Descriptive statistics
| Standard deviation | 0.8629110184 |
|---|---|
| Coefficient of variation (CV) | 0.4112286271 |
| Kurtosis | -1.112339466 |
| Mean | 2.098372928 |
| Median Absolute Deviation (MAD) | 0.757 |
| Skewness | 0.3317638835 |
| Sum | 759.611 |
| Variance | 0.7446154256 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.078 | 4 | 0.7% |
| 1.066 | 3 | 0.5% |
| 2.488 | 3 | 0.5% |
| 2.211 | 3 | 0.5% |
| 1.058 | 2 | 0.3% |
| 2.48 | 2 | 0.3% |
| 2.678 | 2 | 0.3% |
| 1.082 | 2 | 0.3% |
| 1.199 | 2 | 0.3% |
| 3.168 | 2 | 0.3% |
| Other values (321) | 337 | |
| (Missing) | 228 |
| Value | Count | Frequency (%) |
| 0.9 | 1 | |
| 0.917 | 1 | |
| 0.923 | 1 | |
| 0.961 | 1 | |
| 0.979 | 1 | |
| 0.994 | 1 | |
| 0.998 | 1 | |
| 1.006 | 2 | |
| 1.008 | 1 | |
| 1.009 | 1 |
| Value | Count | Frequency (%) |
| 4.002 | 1 | |
| 3.989 | 1 | |
| 3.849 | 1 | |
| 3.837 | 1 | |
| 3.801 | 1 | |
| 3.774 | 1 | |
| 3.746 | 1 | |
| 3.74 | 1 | |
| 3.735 | 1 | |
| 3.709 | 1 |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of fuel, blended
| Distinct | 311 |
|---|---|
| Distinct (%) | 95.4% |
| Missing | 264 |
| Missing (%) | 44.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.369110429 |
| Minimum | 0.984 |
|---|---|
| Maximum | 4.19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.984 |
|---|---|
| 5-th percentile | 1.11775 |
| Q1 | 1.51825 |
| median | 2.3835 |
| Q3 | 3.0165 |
| 95-th percentile | 3.8025 |
| Maximum | 4.19 |
| Range | 3.206 |
| Interquartile range (IQR) | 1.49825 |
Descriptive statistics
| Standard deviation | 0.8829988867 |
|---|---|
| Coefficient of variation (CV) | 0.3727132664 |
| Kurtosis | -1.155138768 |
| Mean | 2.369110429 |
| Median Absolute Deviation (MAD) | 0.7605 |
| Skewness | 0.1007680195 |
| Sum | 772.33 |
| Variance | 0.7796870339 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.129 | 2 | 0.3% |
| 1.483 | 2 | 0.3% |
| 1.5 | 2 | 0.3% |
| 1.543 | 2 | 0.3% |
| 2.663 | 2 | 0.3% |
| 1.114 | 2 | 0.3% |
| 1.307 | 2 | 0.3% |
| 2.343 | 2 | 0.3% |
| 3.202 | 2 | 0.3% |
| 2.832 | 2 | 0.3% |
| Other values (301) | 306 | |
| (Missing) | 264 |
| Value | Count | Frequency (%) |
| 0.984 | 1 | |
| 1.008 | 1 | |
| 1.016 | 1 | |
| 1.043 | 1 | |
| 1.045 | 1 | |
| 1.046 | 1 | |
| 1.054 | 1 | |
| 1.057 | 1 | |
| 1.067 | 1 | |
| 1.071 | 1 |
| Value | Count | Frequency (%) |
| 4.19 | 1 | |
| 4.187 | 1 | |
| 4.032 | 1 | |
| 4.025 | 1 | |
| 4.017 | 1 | |
| 3.949 | 1 | |
| 3.939 | 1 | |
| 3.919 | 1 | |
| 3.914 | 1 | |
| 3.86 | 1 |
Regular Motor Gasoline, All Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGCumulative mean of all categories
| Distinct | 322 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 228 |
| Missing (%) | 38.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.142513812 |
| Minimum | 0.921 |
|---|---|
| Maximum | 4.062 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.921 |
|---|---|
| 5-th percentile | 1.0471 |
| Q1 | 1.23125 |
| median | 2.182 |
| Q3 | 2.80825 |
| 95-th percentile | 3.66045 |
| Maximum | 4.062 |
| Range | 3.141 |
| Interquartile range (IQR) | 1.577 |
Descriptive statistics
| Standard deviation | 0.8830022923 |
|---|---|
| Coefficient of variation (CV) | 0.4121337689 |
| Kurtosis | -1.151839223 |
| Mean | 2.142513812 |
| Median Absolute Deviation (MAD) | 0.785 |
| Skewness | 0.2915628142 |
| Sum | 775.59 |
| Variance | 0.7796930483 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.114 | 4 | 0.7% |
| 1.078 | 4 | 0.7% |
| 2.836 | 3 | 0.5% |
| 1.131 | 3 | 0.5% |
| 1.111 | 3 | 0.5% |
| 1.062 | 3 | 0.5% |
| 2.555 | 3 | 0.5% |
| 1.969 | 2 | 0.3% |
| 1.397 | 2 | 0.3% |
| 2.859 | 2 | 0.3% |
| Other values (312) | 333 | |
| (Missing) | 228 |
| Value | Count | Frequency (%) |
| 0.921 | 1 | |
| 0.939 | 1 | |
| 0.945 | 1 | |
| 0.982 | 1 | |
| 0.995 | 1 | |
| 0.998 | 1 | |
| 1.006 | 1 | |
| 1.008 | 1 | |
| 1.009 | 2 | |
| 1.013 | 1 |
| Value | Count | Frequency (%) |
| 4.062 | 1 | |
| 4.054 | 1 | |
| 3.906 | 1 | |
| 3.9 | 1 | |
| 3.852 | 1 | |
| 3.849 | 1 | |
| 3.8 | 1 | |
| 3.779 | 1 | |
| 3.766 | 1 | |
| 3.746 | 1 |
On-Highway Diesel Fuel Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice for diesel fuel
| Distinct | 301 |
|---|---|
| Distinct (%) | 92.3% |
| Missing | 264 |
| Missing (%) | 44.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.445389571 |
| Minimum | 0.959 |
|---|---|
| Maximum | 4.703 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.959 |
|---|---|
| 5-th percentile | 1.085 |
| Q1 | 1.42525 |
| median | 2.5105 |
| Q3 | 3.12825 |
| 95-th percentile | 3.996 |
| Maximum | 4.703 |
| Range | 3.744 |
| Interquartile range (IQR) | 1.703 |
Descriptive statistics
| Standard deviation | 1.000537845 |
|---|---|
| Coefficient of variation (CV) | 0.4091527409 |
| Kurtosis | -1.187072514 |
| Mean | 2.445389571 |
| Median Absolute Deviation (MAD) | 0.937 |
| Skewness | 0.1223904225 |
| Sum | 797.197 |
| Variance | 1.00107598 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.12 | 3 | 0.5% |
| 3.905 | 3 | 0.5% |
| 2.997 | 2 | 0.3% |
| 2.785 | 2 | 0.3% |
| 1.637 | 2 | 0.3% |
| 1.482 | 2 | 0.3% |
| 2.519 | 2 | 0.3% |
| 3.045 | 2 | 0.3% |
| 1.42 | 2 | 0.3% |
| 3.069 | 2 | 0.3% |
| Other values (291) | 304 | |
| (Missing) | 264 |
| Value | Count | Frequency (%) |
| 0.959 | 1 | |
| 0.967 | 1 | |
| 0.973 | 1 | |
| 0.997 | 1 | |
| 1.007 | 1 | |
| 1.022 | 1 | |
| 1.024 | 1 | |
| 1.029 | 1 | |
| 1.039 | 1 | |
| 1.041 | 1 |
| Value | Count | Frequency (%) |
| 4.703 | 1 | |
| 4.677 | 1 | |
| 4.425 | 1 | |
| 4.302 | 1 | |
| 4.127 | 1 | |
| 4.12 | 1 | |
| 4.115 | 1 | |
| 4.111 | 1 | |
| 4.094 | 1 | |
| 4.084 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Date | Year | Month | Leaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Premium Gasoline, U.S. City Average Retail Price | All Grades of Gasoline, U.S. City Average Retail Price | Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Regular Motor Gasoline, All Areas, Retail Price | On-Highway Diesel Fuel Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1973-01-01 | 1973 | 1 | 0.465 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 1973-02-01 | 1973 | 2 | 0.491 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 1973-03-01 | 1973 | 3 | 0.528 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 1973-04-01 | 1973 | 4 | 0.537 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 1973-05-01 | 1973 | 5 | 0.550 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 1973-06-01 | 1973 | 6 | 0.556 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 1973-07-01 | 1973 | 7 | 0.558 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 1973-08-01 | 1973 | 8 | 0.554 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 1973-09-01 | 1973 | 9 | 0.550 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 1973-10-01 | 1973 | 10 | 0.402 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| Date | Year | Month | Leaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Premium Gasoline, U.S. City Average Retail Price | All Grades of Gasoline, U.S. City Average Retail Price | Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Regular Motor Gasoline, All Areas, Retail Price | On-Highway Diesel Fuel Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 580 | 2021-05-01 | 2021 | 5 | 0.0 | 2.972 | 3.596 | 3.041 | 2.885 | 3.202 | 2.985 | 3.217 |
| 581 | 2021-06-01 | 2021 | 6 | 0.0 | 3.154 | 3.802 | 3.245 | 2.964 | 3.281 | 3.064 | 3.287 |
| 582 | 2021-07-01 | 2021 | 7 | 0.0 | 3.233 | 3.897 | 3.326 | 3.044 | 3.339 | 3.136 | 3.339 |
| 583 | 2021-08-01 | 2021 | 8 | 0.0 | 3.255 | 3.938 | 3.351 | 3.062 | 3.368 | 3.158 | 3.350 |
| 584 | 2021-09-01 | 2021 | 9 | 0.0 | 3.265 | 3.945 | 3.361 | 3.081 | 3.382 | 3.175 | 3.384 |
| 585 | 2021-10-01 | 2021 | 10 | 0.0 | 3.385 | 4.040 | 3.477 | 3.193 | 3.506 | 3.291 | 3.612 |
| 586 | 2021-11-01 | 2021 | 11 | 0.0 | 3.482 | 4.148 | 3.576 | 3.275 | 3.659 | 3.395 | 3.727 |
| 587 | 2021-12-01 | 2021 | 12 | 0.0 | 3.408 | 4.100 | 3.505 | 3.168 | 3.608 | 3.307 | 3.641 |
| 588 | 2022-01-01 | 2022 | 1 | 0.0 | 3.413 | 4.102 | 3.500 | 3.187 | 3.595 | 3.315 | 3.724 |
| 589 | 2022-02-01 | 2022 | 2 | 0.0 | 3.592 | 4.244 | 3.675 | 3.400 | 3.773 | 3.517 | 4.032 |